Stored Procedures [dbo].[BAEImisNameSecurityAdd]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Idvarchar(10)10
@loginDisabledbit1
@expirationDatedatetime8
@lastlogindatetime8
@previousLogindatetime8
@webLoginvarchar(60)60
@passwordvarchar(100)100
SQL Script
create procedure [dbo].[BAEImisNameSecurityAdd] @Id varchar(10),
     @loginDisabled bit,
     @expirationDate datetime,
     @lastlogin datetime,
     @previousLogin datetime,
     @webLogin varchar(60),
     @password varchar(100) as
INSERT INTO Name_Security(ID, LOGIN_DISABLED, EXPIRATION_DATE, LAST_LOGIN, PREVIOUS_LOGIN, WEB_LOGIN, [PASSWORD])
    Values(@Id, @loginDisabled, @expirationDate, @lastlogin, @previousLogin, @webLogin,@password)

    SELECT @@Identity AS 'Id'

GO
Uses